Car Purchasing Data Profiling Report

Dataset statistics

Number of variables	15
Number of observations	500
Missing cells	500
Missing cells (%)	6.7%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	58.7 KiB
Average record size in memory	120.3 B

Variable types

Text	4
Categorical	1
Numeric	9
Unsupported	1

Alerts

`BasePay` is highly overall correlated with `OvertimePay`	High correlation
`OvertimePay` is highly overall correlated with `BasePay`	High correlation
`TotalPay` is highly overall correlated with `TotalPayBenefits`	High correlation
`TotalPayBenefits` is highly overall correlated with `TotalPay`	High correlation
`age` is highly overall correlated with `car purchase amount`	High correlation
`car purchase amount` is highly overall correlated with `age`	High correlation
`Benefits` has 500 (100.0%) missing values	Missing
`customer e-mail` has unique values	Unique
`credit card debt` has unique values	Unique
`net worth` has unique values	Unique
`car purchase amount` has unique values	Unique
`Benefits` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`OvertimePay` has 169 (33.8%) zeros	Zeros
`OtherPay` has 55 (11.0%) zeros	Zeros

Reproduction

Analysis started	2024-10-21 03:36:58.277980
Analysis finished	2024-10-21 03:37:49.366223
Duration	51.09 seconds
Software version	ydata-profiling vv4.10.0
Download configuration	config.json

customer name
Text

Distinct	498
Distinct (%)	99.6%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

Length

Max length	22
Median length	17
Mean length	12.804
Min length	3

Characters and Unicode

Total characters	6402
Distinct characters	55
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	496 ?
Unique (%)	99.2%

Sample

1st row	Martina Avila
2nd row	Harlan Barnes
3rd row	Naomi Rodriquez
4th row	Jade Cunningham
5th row	Cedric Leach

Value	Count	Frequency (%)
d	12	1.1%
q	11	1.0%
f	11	1.0%
u	10	0.9%
l	10	0.9%
a	10	0.9%
p	9	0.8%
h	9	0.8%
m	8	0.7%
s	8	0.7%
Other values (706)	1001	91.1%

Most occurring characters

Value	Count	Frequency (%)
e	612	9.6%
	599	9.4%
a	561	8.8%
n	443	6.9%
r	416	6.5%
l	334	5.2%
o	308	4.8%
i	307	4.8%
s	204	3.2%
.	200	3.1%
Other values (45)	2418	37.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	6402	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	612	9.6%
	599	9.4%
a	561	8.8%
n	443	6.9%
r	416	6.5%
l	334	5.2%
o	308	4.8%
i	307	4.8%
s	204	3.2%
.	200	3.1%
Other values (45)	2418	37.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	6402	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	612	9.6%
	599	9.4%
a	561	8.8%
n	443	6.9%
r	416	6.5%
l	334	5.2%
o	308	4.8%
i	307	4.8%
s	204	3.2%
.	200	3.1%
Other values (45)	2418	37.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	6402	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	612	9.6%
	599	9.4%
a	561	8.8%
n	443	6.9%
r	416	6.5%
l	334	5.2%
o	308	4.8%
i	307	4.8%
s	204	3.2%
.	200	3.1%
Other values (45)	2418	37.8%

JobTitle
Text

Distinct	82
Distinct (%)	16.4%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

Length

Max length	50
Median length	44
Mean length	25.298
Min length	5

Characters and Unicode

Total characters	12649
Distinct characters	30
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	36 ?
Unique (%)	7.2%

Sample

1st row	GENERAL MANAGER-METROPOLITAN TRANSIT AUTHORITY
2nd row	CAPTAIN III (POLICE DEPARTMENT)
3rd row	CAPTAIN III (POLICE DEPARTMENT)
4th row	WIRE ROPE CABLE MAINTENANCE MECHANIC
5th row	DEPUTY CHIEF OF DEPARTMENT,(FIRE DEPARTMENT)

Value	Count	Frequency (%)
department	182	11.5%
fire	134	8.5%
iii	104	6.6%
police	104	6.6%
captain	70	4.4%
chief	63	4.0%
firefighter	55	3.5%
lieutenant	53	3.4%
deputy	39	2.5%
supervisor	37	2.3%
Other values (103)	737	46.7%

Most occurring characters

Value	Count	Frequency (%)
I	1552	12.3%
E	1500	11.9%
	1078	8.5%
T	1073	8.5%
R	933	7.4%
A	863	6.8%
N	811	6.4%
P	650	5.1%
C	531	4.2%
S	528	4.2%
Other values (20)	3130	24.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	12649	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
I	1552	12.3%
E	1500	11.9%
	1078	8.5%
T	1073	8.5%
R	933	7.4%
A	863	6.8%
N	811	6.4%
P	650	5.1%
C	531	4.2%
S	528	4.2%
Other values (20)	3130	24.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	12649	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
I	1552	12.3%
E	1500	11.9%
	1078	8.5%
T	1073	8.5%
R	933	7.4%
A	863	6.8%
N	811	6.4%
P	650	5.1%
C	531	4.2%
S	528	4.2%
Other values (20)	3130	24.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	12649	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
I	1552	12.3%
E	1500	11.9%
	1078	8.5%
T	1073	8.5%
R	933	7.4%
A	863	6.8%
N	811	6.4%
P	650	5.1%
C	531	4.2%
S	528	4.2%
Other values (20)	3130	24.7%

customer e-mail
Text

UNIQUE

Distinct	500
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

Length

Max length	58
Median length	41
Mean length	27.606
Min length	10

Characters and Unicode

Total characters	13803
Distinct characters	39
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	500 ?
Unique (%)	100.0%

Sample

1st row	cubilia.Curae.Phasellus@quisaccumsanconvallis.edu
2nd row	eu.dolor@diam.co.uk
3rd row	vulputate.mauris.sagittis@ametconsectetueradipiscing.co.uk
4th row	malesuada@dignissim.com
5th row	felis.ullamcorper.viverra@egetmollislectus.net

Value	Count	Frequency (%)
felis.ullamcorper.viverra@egetmollislectus.net	1	0.2%
camaron.marla@hotmail.com	1	0.2%
cubilia.curae.phasellus@quisaccumsanconvallis.edu	1	0.2%
eu.dolor@diam.co.uk	1	0.2%
phasellus.fermentum@dictumplacerataugue.net	1	0.2%
ipsum.phasellus@egestasblanditnam.edu	1	0.2%
iaculis.enim@nislelementum.edu	1	0.2%
porttitor.tellus@elitelit.org	1	0.2%
felis.nulla@mi.ca	1	0.2%
curabitur.egestas.nunc@fermentumfermentum.ca	1	0.2%
Other values (490)	490	98.0%

Most occurring characters

Value	Count	Frequency (%)
e	1383	10.0%
u	1129	8.2%
.	1067	7.7%
i	1053	7.6%
a	963	7.0%
s	941	6.8%
t	899	6.5%
n	744	5.4%
c	730	5.3%
o	723	5.2%
Other values (29)	4171	30.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	13803	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	1383	10.0%
u	1129	8.2%
.	1067	7.7%
i	1053	7.6%
a	963	7.0%
s	941	6.8%
t	899	6.5%
n	744	5.4%
c	730	5.3%
o	723	5.2%
Other values (29)	4171	30.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	13803	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	1383	10.0%
u	1129	8.2%
.	1067	7.7%
i	1053	7.6%
a	963	7.0%
s	941	6.8%
t	899	6.5%
n	744	5.4%
c	730	5.3%
o	723	5.2%
Other values (29)	4171	30.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	13803	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	1383	10.0%
u	1129	8.2%
.	1067	7.7%
i	1053	7.6%
a	963	7.0%
s	941	6.8%
t	899	6.5%
n	744	5.4%
c	730	5.3%
o	723	5.2%
Other values (29)	4171	30.2%

country
Text

Distinct	211
Distinct (%)	42.2%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

Length

Max length	44
Median length	32
Mean length	10.266
Min length	4

Characters and Unicode

Total characters	5133
Distinct characters	59
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	59 ?
Unique (%)	11.8%

Sample

1st row	Bulgaria
2nd row	Belize
3rd row	Algeria
4th row	Cook Islands
5th row	Brazil

Value	Count	Frequency (%)
islands	35	4.7%
and	30	4.0%
saint	21	2.8%
guinea	12	1.6%
united	10	1.3%
island	10	1.3%
french	8	1.1%
south	8	1.1%
republic	6	0.8%
israel	6	0.8%
Other values (250)	602	80.5%

Most occurring characters

Value	Count	Frequency (%)
a	721	14.0%
n	426	8.3%
i	413	8.0%
e	386	7.5%
r	282	5.5%
	248	4.8%
l	233	4.5%
o	232	4.5%
t	230	4.5%
s	223	4.3%
Other values (49)	1739	33.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	5133	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	721	14.0%
n	426	8.3%
i	413	8.0%
e	386	7.5%
r	282	5.5%
	248	4.8%
l	233	4.5%
o	232	4.5%
t	230	4.5%
s	223	4.3%
Other values (49)	1739	33.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	5133	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	721	14.0%
n	426	8.3%
i	413	8.0%
e	386	7.5%
r	282	5.5%
	248	4.8%
l	233	4.5%
o	232	4.5%
t	230	4.5%
s	223	4.3%
Other values (49)	1739	33.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	5133	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	721	14.0%
n	426	8.3%
i	413	8.0%
e	386	7.5%
r	282	5.5%
	248	4.8%
l	233	4.5%
o	232	4.5%
t	230	4.5%
s	223	4.3%
Other values (49)	1739	33.9%

gender
Categorical

Distinct	2
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

1	253
0	247

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	500
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	253	50.6%
0	247	49.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	253	50.6%
0	247	49.4%

Most occurring characters

Value	Count	Frequency (%)
1	253	50.6%
0	247	49.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	500	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	253	50.6%
0	247	49.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	500	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	253	50.6%
0	247	49.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	500	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	253	50.6%
0	247	49.4%

age
Real number (ℝ)

HIGH CORRELATION

Distinct	43
Distinct (%)	8.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	46.224

Minimum	20
Maximum	70
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.0 KiB

Quantile statistics

Minimum	20
5-th percentile	33
Q1	41
median	46
Q3	52
95-th percentile	59.05
Maximum	70
Range	50
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	7.9903389
Coefficient of variation (CV)	0.17286126
Kurtosis	-0.07296831
Mean	46.224
Median Absolute Deviation (MAD)	5
Skewness	0.0080821527
Sum	23112
Variance	63.845515
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=43)

Value	Count	Frequency (%)
43	34	6.8%
51	29	5.8%
42	26	5.2%
48	25	5.0%
47	25	5.0%
40	24	4.8%
44	23	4.6%
45	23	4.6%
53	20	4.0%
50	19	3.8%
Other values (33)	252	50.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20	1	0.2%
22	1	0.2%
25	1	0.2%
27	1	0.2%
28	1	0.2%
29	2	0.4%
30	3	0.6%
31	1	0.2%
32	9	1.8%
33	10	2.0%

Value	Count	Frequency (%)
70	2	0.4%
65	1	0.2%
64	1	0.2%
63	6	1.2%
62	5	1.0%
61	5	1.0%
60	5	1.0%
59	6	1.2%
58	7	1.4%
57	17	3.4%

BasePay
Real number (ℝ)

HIGH CORRELATION

Distinct	371
Distinct (%)	74.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	151066.63

Minimum	25400
Maximum	294580.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.0 KiB

Quantile statistics

Minimum	25400
5-th percentile	87357.37
Q1	116316.36
median	140546.9
Q3	188314.51
95-th percentile	220158.61
Maximum	294580.02
Range	269180.02
Interquartile range (IQR)	71998.153

Descriptive statistics

Standard deviation	44402.93
Coefficient of variation (CV)	0.29392944
Kurtosis	-0.29836746
Mean	151066.63
Median Absolute Deviation (MAD)	34612.24
Skewness	0.33005319
Sum	75533315
Variance	1.9716202 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
105934.66	10	2.0%
105934.64	10	2.0%
105934.65	10	2.0%
123105	9	1.8%
140546.88	8	1.6%
192379.6	6	1.2%
188341.6	6	1.2%
188341.62	6	1.2%
122404.98	5	1.0%
105934.67	5	1.0%
Other values (361)	425	85.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
25400	1	0.2%
60373.82	1	0.2%
61232	1	0.2%
63625.16	1	0.2%
63811.18	1	0.2%
63878.03	1	0.2%
73754.05	1	0.2%
75870.3	1	0.2%
76298.77	1	0.2%
76424.2	1	0.2%

Value	Count	Frequency (%)
294580.02	1	0.2%
285262	1	0.2%
271329.03	1	0.2%
268604.57	1	0.2%
261717.6	1	0.2%
257510.59	1	0.2%
257510.48	1	0.2%
257510.44	1	0.2%
256576.96	1	0.2%
256470.41	1	0.2%

OvertimePay
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	329
Distinct (%)	65.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	34445.374

Minimum	0
Maximum	245131.88
Zeros	169
Zeros (%)	33.8%
Negative	0
Negative (%)	0.0%
Memory size	4.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	24079.42
Q3	64893.007
95-th percentile	102135.6
Maximum	245131.88
Range	245131.88
Interquartile range (IQR)	64893.007

Descriptive statistics

Standard deviation	37322.38
Coefficient of variation (CV)	1.0835237
Kurtosis	1.0205521
Mean	34445.374
Median Absolute Deviation (MAD)	24079.42
Skewness	0.94254468
Sum	17222687
Variance	1.39296 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	169	33.8%
1109.1	3	0.6%
7437	2	0.4%
245131.88	1	0.2%
106088.18	1	0.2%
56120.71	1	0.2%
9737	1	0.2%
8601	1	0.2%
89062.9	1	0.2%
86362.68	1	0.2%
Other values (319)	319	63.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	169	33.8%
377.21	1	0.2%
444.6	1	0.2%
619.4	1	0.2%
743.34	1	0.2%
880.16	1	0.2%
1068.45	1	0.2%
1109.1	3	0.6%
1131.28	1	0.2%
1134.34	1	0.2%

Value	Count	Frequency (%)
245131.88	1	0.2%
139102.95	1	0.2%
135159.38	1	0.2%
126778.88	1	0.2%
126725.82	1	0.2%
119951.72	1	0.2%
119407.7	1	0.2%
119397.26	1	0.2%
118949.93	1	0.2%
115239.98	1	0.2%

OtherPay
Real number (ℝ)

ZEROS

Distinct	437
Distinct (%)	87.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	25762.908

Minimum	0
Maximum	400184.25
Zeros	55
Zeros (%)	11.0%
Negative	0
Negative (%)	0.0%
Memory size	4.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	10161.333
median	17475.785
Q3	28726.082
95-th percentile	87151.375
Maximum	400184.25
Range	400184.25
Interquartile range (IQR)	18564.75

Descriptive statistics

Standard deviation	33597.479
Coefficient of variation (CV)	1.3041027
Kurtosis	34.962625
Mean	25762.908
Median Absolute Deviation (MAD)	9715.91
Skewness	4.5162553
Sum	12881454
Variance	1.1287906 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	55	11.0%
12000	3	0.6%
1080.96	3	0.6%
21055.17	2	0.4%
17542.29	2	0.4%
32080.36	2	0.4%
10000	2	0.4%
15365.22	2	0.4%
189082.74	1	0.2%
23865	1	0.2%
Other values (427)	427	85.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	55	11.0%
114.37	1	0.2%
237	1	0.2%
408	1	0.2%
702	1	0.2%
760.4	1	0.2%
773.7	1	0.2%
819.03	1	0.2%
837.79	1	0.2%
841.15	1	0.2%

Value	Count	Frequency (%)
400184.25	1	0.2%
198306.9	1	0.2%
189082.74	1	0.2%
182234.59	1	0.2%
142094.49	1	0.2%
139279.69	1	0.2%
137811.38	1	0.2%
135684.25	1	0.2%
134426.14	1	0.2%
133695.76	1	0.2%

Benefits
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	500
Missing (%)	100.0%
Memory size	4.0 KiB

TotalPay
Real number (ℝ)

HIGH CORRELATION

Distinct	491
Distinct (%)	98.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	211274.91

Minimum	185724.5
Maximum	567595.43
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.0 KiB

Quantile statistics

Minimum	185724.5
5-th percentile	186645.93
Q1	192696.08
median	200595.26
Q3	217400.32
95-th percentile	268109.21
Maximum	567595.43
Range	381870.93
Interquartile range (IQR)	24704.243

Descriptive statistics

Standard deviation	34040.951
Coefficient of variation (CV)	0.1611216
Kurtosis	41.287891
Mean	211274.91
Median Absolute Deviation (MAD)	10259.05
Skewness	4.9554096
Sum	1.0563746 × 10⁸
Variance	1.1587864 × 10⁹
Monotonicity	Decreasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
192379.6	4	0.8%
214988.68	3	0.6%
185724.5	3	0.6%
220788.36	2	0.4%
196886.55	2	0.4%
538909.28	1	0.2%
335279.91	1	0.2%
332343.61	1	0.2%
326373.19	1	0.2%
316285.74	1	0.2%
Other values (481)	481	96.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
185724.5	3	0.6%
185760.92	1	0.2%
185951.55	1	0.2%
186049.41	1	0.2%
186075.92	1	0.2%
186105.02	1	0.2%
186191.94	1	0.2%
186231.74	1	0.2%
186297.21	1	0.2%
186341.79	1	0.2%

Value	Count	Frequency (%)
567595.43	1	0.2%
538909.28	1	0.2%
335279.91	1	0.2%
332343.61	1	0.2%
326373.19	1	0.2%
316285.74	1	0.2%
315981.05	1	0.2%
307899.46	1	0.2%
303427.55	1	0.2%
302377.73	1	0.2%

TotalPayBenefits
Real number (ℝ)

HIGH CORRELATION

Distinct	491
Distinct (%)	98.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	211274.91

Minimum	185724.5
Maximum	567595.43
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.0 KiB

Quantile statistics

Minimum	185724.5
5-th percentile	186645.93
Q1	192696.08
median	200595.26
Q3	217400.32
95-th percentile	268109.21
Maximum	567595.43
Range	381870.93
Interquartile range (IQR)	24704.243

Descriptive statistics

Standard deviation	34040.951
Coefficient of variation (CV)	0.1611216
Kurtosis	41.287891
Mean	211274.91
Median Absolute Deviation (MAD)	10259.05
Skewness	4.9554096
Sum	1.0563746 × 10⁸
Variance	1.1587864 × 10⁹
Monotonicity	Decreasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
192379.6	4	0.8%
214988.68	3	0.6%
185724.5	3	0.6%
220788.36	2	0.4%
196886.55	2	0.4%
538909.28	1	0.2%
335279.91	1	0.2%
332343.61	1	0.2%
326373.19	1	0.2%
316285.74	1	0.2%
Other values (481)	481	96.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
185724.5	3	0.6%
185760.92	1	0.2%
185951.55	1	0.2%
186049.41	1	0.2%
186075.92	1	0.2%
186105.02	1	0.2%
186191.94	1	0.2%
186231.74	1	0.2%
186297.21	1	0.2%
186341.79	1	0.2%

Value	Count	Frequency (%)
567595.43	1	0.2%
538909.28	1	0.2%
335279.91	1	0.2%
332343.61	1	0.2%
326373.19	1	0.2%
316285.74	1	0.2%
315981.05	1	0.2%
307899.46	1	0.2%
303427.55	1	0.2%
302377.73	1	0.2%

credit card debt
Real number (ℝ)

UNIQUE

Distinct	500
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9607.645

Minimum	100
Maximum	20000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.0 KiB

Quantile statistics

Minimum	100
5-th percentile	3848.5025
Q1	7397.5158
median	9655.0356
Q3	11798.867
95-th percentile	15193.805
Maximum	20000
Range	19900
Interquartile range (IQR)	4401.3517

Descriptive statistics

Standard deviation	3489.188
Coefficient of variation (CV)	0.36316787
Kurtosis	0.099148574
Mean	9607.645
Median Absolute Deviation (MAD)	2220.4134
Skewness	-0.063724404
Sum	4803822.5
Variance	12174433
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9391.341628	1	0.2%
11609.38091	1	0.2%
9572.957136	1	0.2%
11160.35506	1	0.2%
10373.00856	1	0.2%
14297.25366	1	0.2%
10769.75059	1	0.2%
9141.668545	1	0.2%
11561.07365	1	0.2%
6596.01369	1	0.2%
Other values (490)	490	98.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
100	1	0.2%
594.8049491	1	0.2%
632.0528524	1	0.2%
640.045378	1	0.2%
861.8166529	1	0.2%
893.2353408	1	0.2%
921.5340234	1	0.2%
1065.607589	1	0.2%
1696.989764	1	0.2%
1726.809885	1	0.2%

Value	Count	Frequency (%)
20000	1	0.2%
19692.91262	1	0.2%
18693.14652	1	0.2%
18361.24915	1	0.2%
17870.63765	1	0.2%
17805.57607	1	0.2%
17462.07506	1	0.2%
17452.92179	1	0.2%
17142.41332	1	0.2%
16978.52745	1	0.2%

net worth
Real number (ℝ)

UNIQUE

Distinct	500
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	431475.71

Minimum	20000
Maximum	1000000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.0 KiB

Quantile statistics

Minimum	20000
5-th percentile	158464.61
Q1	299824.2
median	426750.12
Q3	557324.48
95-th percentile	720603.9
Maximum	1000000
Range	980000
Interquartile range (IQR)	257500.28

Descriptive statistics

Standard deviation	173536.76
Coefficient of variation (CV)	0.40219357
Kurtosis	-0.33406563
Mean	431475.71
Median Absolute Deviation (MAD)	128997.55
Skewness	0.13975525
Sum	2.1573786 × 10⁸
Variance	3.0115006 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
462946.4924	1	0.2%
238961.2505	1	0.2%
530973.9078	1	0.2%
638467.1773	1	0.2%
620355.2658	1	0.2%
247421.9185	1	0.2%
276466.6203	1	0.2%
531840.3342	1	0.2%
421891.846	1	0.2%
266939.1746	1	0.2%
Other values (490)	490	98.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20000	1	0.2%
27888.74525	1	0.2%
48620.32123	1	0.2%
53366.13861	1	0.2%
59630.07789	1	0.2%
62149.94034	1	0.2%
69821.6376	1	0.2%
74257.82785	1	0.2%
85520.85055	1	0.2%
97706.89181	1	0.2%

Value	Count	Frequency (%)
1000000	1	0.2%
891439.8761	1	0.2%
856287.1522	1	0.2%
854283.5574	1	0.2%
853913.8532	1	0.2%
830430.3692	1	0.2%
819002.1748	1	0.2%
811594.0392	1	0.2%
805075.5197	1	0.2%
793986.6155	1	0.2%

car purchase amount
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	500
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	44209.799

Minimum	9000
Maximum	80000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.0 KiB

Quantile statistics

Minimum	9000
5-th percentile	27623.505
Q1	37629.896
median	43997.783
Q3	51254.71
95-th percentile	62070.498
Maximum	80000
Range	71000
Interquartile range (IQR)	13624.813

Descriptive statistics

Standard deviation	10773.179
Coefficient of variation (CV)	0.24368305
Kurtosis	0.22723801
Mean	44209.799
Median Absolute Deviation (MAD)	6741.5855
Skewness	-0.030790505
Sum	22104900
Variance	1.1606138 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
45107.22566	1	0.2%
35321.45877	1	0.2%
45115.52566	1	0.2%
42925.70921	1	0.2%
55377.87697	1	0.2%
45015.67953	1	0.2%
21471.11367	1	0.2%
53049.44567	1	0.2%
53110.88052	1	0.2%
36517.70996	1	0.2%
Other values (490)	490	98.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
9000	1	0.2%
10092.22509	1	0.2%
12536.93842	1	0.2%
12895.71468	1	0.2%
17584.56963	1	0.2%
19525.29827	1	0.2%
19553.2739	1	0.2%
20653.21409	1	0.2%
21471.11367	1	0.2%
22091.11839	1	0.2%

Value	Count	Frequency (%)
80000	1	0.2%
70878.29664	1	0.2%
70598.96768	1	0.2%
69669.47402	1	0.2%
68925.09447	1	0.2%
68678.4352	1	0.2%
67422.36313	1	0.2%
67120.89878	1	0.2%
67092.23276	1	0.2%
66888.93694	1	0.2%

Auto

Heatmap
Table

	BasePay	OtherPay	OvertimePay	TotalPay	TotalPayBenefits	age	car purchase amount	credit card debt	gender	net worth
BasePay	1.000	-0.408	-0.771	0.184	0.184	0.019	0.018	-0.013	0.000	0.033
OtherPay	-0.408	1.000	0.164	0.189	0.189	-0.030	-0.053	0.082	0.067	0.022
OvertimePay	-0.771	0.164	1.000	0.126	0.126	-0.011	-0.018	0.021	0.081	-0.027
TotalPay	0.184	0.189	0.126	1.000	1.000	0.052	0.007	0.106	0.101	0.029
TotalPayBenefits	0.184	0.189	0.126	1.000	1.000	0.052	0.007	0.106	0.101	0.029
age	0.019	-0.030	-0.011	0.052	0.052	1.000	0.624	0.020	0.000	0.016
car purchase amount	0.018	-0.053	-0.018	0.007	0.007	0.624	1.000	0.025	0.000	0.464
credit card debt	-0.013	0.082	0.021	0.106	0.106	0.020	0.025	1.000	0.007	-0.047
gender	0.000	0.067	0.081	0.101	0.101	0.000	0.000	0.007	1.000	0.121
net worth	0.033	0.022	-0.027	0.029	0.029	0.016	0.464	-0.047	0.121	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	customer name	JobTitle	customer e-mail	country	gender	age	BasePay	OvertimePay	OtherPay	Benefits	TotalPay	TotalPayBenefits	credit card debt	net worth	car purchase amount
0	Martina Avila	GENERAL MANAGER-METROPOLITAN TRANSIT AUTHORITY	cubilia.Curae.Phasellus@quisaccumsanconvallis.edu	Bulgaria	0	42	167411.18	0.00	400184.25	NaN	567595.43	567595.43	11609.380910	238961.2505	35321.45877
1	Harlan Barnes	CAPTAIN III (POLICE DEPARTMENT)	eu.dolor@diam.co.uk	Belize	0	41	155966.02	245131.88	137811.38	NaN	538909.28	538909.28	9572.957136	530973.9078	45115.52566
2	Naomi Rodriquez	CAPTAIN III (POLICE DEPARTMENT)	vulputate.mauris.sagittis@ametconsectetueradipiscing.co.uk	Algeria	1	43	212739.13	106088.18	16452.60	NaN	335279.91	335279.91	11160.355060	638467.1773	42925.70921
3	Jade Cunningham	WIRE ROPE CABLE MAINTENANCE MECHANIC	malesuada@dignissim.com	Cook Islands	1	58	77916.00	56120.71	198306.90	NaN	332343.61	332343.61	14426.164850	548599.0524	67422.36313
4	Cedric Leach	DEPUTY CHIEF OF DEPARTMENT,(FIRE DEPARTMENT)	felis.ullamcorper.viverra@egetmollislectus.net	Brazil	1	57	134401.60	9737.00	182234.59	NaN	326373.19	326373.19	5358.712177	560304.0671	55915.46248
5	Carla Hester	ASSISTANT DEPUTY CHIEF II	mi@Aliquamerat.edu	Liberia	1	57	118602.00	8601.00	189082.74	NaN	316285.74	316285.74	14179.472440	428485.3604	56611.99784
6	Griffin Rivera	BATTALION CHIEF, (FIRE DEPARTMENT)	vehicula@at.co.uk	Syria	1	47	92492.01	89062.90	134426.14	NaN	315981.05	315981.05	5958.460188	326373.1812	28925.70549
7	Orli Casey	DEPUTY DIRECTOR OF INVESTMENTS	nunc.est.mollis@Suspendissetristiqueneque.co.uk	Czech Republic	1	50	256576.96	0.00	51322.50	NaN	307899.46	307899.46	10985.696560	629312.4041	47434.98265
8	Marny Obrien	BATTALION CHIEF, (FIRE DEPARTMENT)	Phasellus@sedsemegestas.org	Armenia	0	47	176932.64	86362.68	40132.23	NaN	303427.55	303427.55	3440.823799	630059.0274	48013.61410
9	Rhonda Chavez	CHIEF OF DEPARTMENT, (FIRE DEPARTMENT)	nec@nuncest.com	Somalia	1	43	285262.00	0.00	17115.73	NaN	302377.73	302377.73	12884.078680	476643.3544	38189.50601

	customer name	JobTitle	customer e-mail	country	gender	age	BasePay	OvertimePay	OtherPay	Benefits	TotalPay	TotalPayBenefits	credit card debt	net worth	car purchase amount
490	Jonah	LIEUTENANT III (POLICE DEPARTMENT)	augue@risusNuncac.co.uk	Myanmar	1	46	149044.77	34003.88	3183.09	NaN	186231.74	186231.74	10711.444720	316128.4002	41352.47071
491	Merrill	NURSE MANAGER	dolor.sit@turpisIn.com	Egypt	1	50	171044.10	0.00	15147.84	NaN	186191.94	186191.94	10072.482980	294506.0844	52785.16947
492	Nolan	CAPTAIN, FIRE SUPPRESSION	Donec.at@neccursus.co.uk	Latvia	0	55	129252.01	30839.74	26013.27	NaN	186105.02	186105.02	9831.184792	523680.7699	60117.67886
493	Winter	FIREFIGHTER	egestas.urna.justo@maurissagittis.edu	Wallis and Futuna	0	43	105934.64	62182.73	17958.55	NaN	186075.92	186075.92	13308.879320	349588.5608	47760.66427
494	Rigel	LIEUTENANT, FIRE DEPARTMENT	egestas.blandit.Nam@semvitaealiquam.com	Sao Tome and Principe	0	52	123013.00	47172.46	15863.95	NaN	186049.41	186049.41	6736.751680	665099.1390	64188.26862
495	Walter	TRANSIT SUPERVISOR	ligula@Cumsociis.ca	Nepal	0	41	87384.60	97729.16	837.79	NaN	185951.55	185951.55	6995.902524	541670.1016	48901.44342
496	Vanna	LIEUTENANT, FIRE DEPARTMENT	Cum.sociis.natoque@Sedmolestie.edu	Zimbabwe	1	38	123105.00	38790.92	23865.00	NaN	185760.92	185760.92	12301.456790	360419.0988	31491.41457
497	Pearl	DEPUTY DIRECTOR V	penatibus.et@massanonante.com	Philippines	1	54	185724.50	0.00	0.00	NaN	185724.50	185724.50	10611.606860	764531.3203	64147.28888
498	Nell	MANAGER VIII	Quisque.varius@arcuVivamussit.net	Botswana	1	59	185724.50	0.00	0.00	NaN	185724.50	185724.50	14013.034510	337826.6382	45442.15353
499	Marla	DEPUTY DIRECTOR V	Camaron.marla@hotmail.com	marlal	1	47	185724.50	0.00	0.00	NaN	185724.50	185724.50	9391.341628	462946.4924	45107.22566

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample